SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_UpdateBulletinEmploymentLectureClickNumber]
    (
      @JOL_BulletinLecture_No INT
    )
AS 
    UPDATE  dbo.JOL_BulletinEmploymentLecture
    SET     JOL_BulletinLecture_ClickNumber = JOL_BulletinLecture_ClickNumber
            + 1
    WHERE   JOL_BulletinLecture_No = @JOL_BulletinLecture_No

GO
